package com.ciaojian.core.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ciaojian.core.model.TimesCard;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author oxiny
 */
public interface TimesCardMapper extends BaseMapper<TimesCard> {

    /**
     * 获取门店次卡信息
     *
     * @param storeId 门店ID
     * @return 门店次卡信息
     */
    @Select("SELECT id,name,expired_type,day,due_date FROM d_times_card WHERE FIND_IN_SET(#{storeId} , store_list) ")
    List<TimesCard> getTimesCardByStoreId(Integer storeId);


}
